This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: Need some TIPs: Managing Databases with many Documents ~Miriam Cisjumisteroden 28.Jan.04 12:23 PM a Web browser General All ReleasesAll Platforms
This is a document management database. The column values are the values of the fields, there are no computed values in the columns. It uses @DBLookup inside the documents. The database growth is of about 300 documents per day, and the documents, once created and numbered, no longer suffer modifications by the users, but Agents can access and modify them. The idea of a search engine with full Text is very good. We already created one and it’s like you said. Searching documents using a search engine is the fastest way, nothing in comparison with the views, which are to slow.
Never then less we need to work with the views, which mean that we have to find some way to improve performance.
Unfortunately due to client internal reasons, we can’t archive.
I would like to change more ideas about the search engine to improve the search. What is the size of the database of your client.